<?php
	require "../dao/college_dao.php";
	require "../dao/grade_dao.php";
	require "../dao/class_dao.php";
	
	$colleges = selectAllcolleges();
	$grades = selectAllgrades();
	$classes = selectAllclasses();
?>
<!DOCTYPE html>
<html lang="zh">
<head>
	<meta charset="UTF-8" />
	<meta name="viewport" content="width=device-width, initial-scale=1.0" />
	<meta http-equiv="X-UA-Compatible" content="ie=edge" />
	<link rel="stylesheet" type="text/css" href="../css/select.css"/>
	<script src="../js/jquery-1.2.6.min.js"></script>
	<title>学生信息表</title>
	<style>
		.span{
			width:200px;
			height:30px;
			margin:0 auto;
			background-color: #fff;
			text-align: center;
			font-size: 24px;
			font-weight: bold;
			line-height: 30px;
		}
	</style>
</head>
<body>
	<div id="wrap">
		<div class="span">学生成绩查询</div>
	 	<form action="selectStu_mark_infor_server.php" method="post">
			<select name="collegeid">
				<option value="0">--请选择学院--</option>
				<?php
					foreach($colleges as $college){
						echo "<option value='{$college["collegeid"]}'>{$college["collegename"]}</option>";
					}	
				?>
			</select>
			<select name="gradeid">
				<option value="0">--请选择年级--</option>
				<?php
					foreach($grades as $grade){
						echo "<option value='{$grade["gradeid"]}'>{$grade["gradename"]}</option>";
					}	
				?>
			</select>
			<select name="classid">
				<option value="0">--请选择班级--</option>
				<?php
					foreach($classes as $class){
						echo "<option value='{$class["classid"]}'>{$class["classname"]}</option>";
					}	
				?>
			</select>
			<input type="submit" value="查询"/>
		</form>
	</div>
</body>
</html>